package com.example.springboot.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.example.springboot.domain.DbBackup;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

@Mapper
public interface DBMapper extends BaseMapper<DbBackup> {

    public List<String> queryTables();

    public Integer addRecord(@Param("dbBackup") DbBackup dbBackup);

    public List<DbBackup> searchRecord(@Param("pageNum")int pageNum, @Param("pageSize") int pageSize,
                                       @Param("name") String name,@Param("type") Integer type, @Param("createTime") String date);
    public Integer searchRecordAll(@Param("name") String name,@Param("type") Integer type, @Param("createTime") String date);
    public Integer removeFile(@Param("idList")List<Integer> idList );
    public  List<DbBackup> queryRecordByIdList(@Param("idList")List<Integer> idList );

}
